Format of mysqladmin tool:
Mysqladmin [option] command [command option] command ......
Option options:
-C number indicates the number of automatic runs, which must be used with-I.
-How long is the I number interval repeated?
Check the status of the
On the server where mysql is installed locally, open cmd and cd to the bin directory under the mysql installation directory. Multiple executable files can be seen in the bin directory, mysqladmin can be used to remotely close the mysql service.
The
Mysqladmin-help command Where command is a one or more of: (Commands may be shortened)
Create databasename Create a new database
Debug Instruct server to write debug information to log
Drop databasename Delete a database and all its
Show MySQL status every two seconds, showing 5 times.# mysqladmin-uroot-p-I 2-c 5 statusTo view the running status of MySQL:#mysqladmin-uroot-p PingMysqladmin Ver 8.42 distrib 5.1.73, for Redhat-linux-gnu on x86_64Copyright (c) and/or, Oracle, its
MySQL root Password Reset error: mysqladmin: connect to server at 'localhost' failed solution 1 login failed, failed to Change password of mysqladmin [root @ mysql var] # mysqladmin-u root password '000000' mysqladmin: connect to server at
In the local installation of MySQL server, open cmd,cd to the MySQL installation directory in the bin directory, the bin directory can see multiple executables, where mysqladmin can be used to remotely shut down the MySQL service.
The mysqladmin
MySQL Client Toolsused in MySQL The client tools have these:MySQL: This is a command line client tool that is installed in the MySQL server, a command-line tool is automatically installed. mysqldump: This is used to back up MySQL Client tools to use
MySql login password forgot and forgot password solution, mysql Login Password
Method 1:
MySQL provides command line parameters for skipping access control and starts the MySQL server by running the following command:
safe_mysqld --skip-grant-tables&
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.